Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_74

R_74

DescriptiveDataStatus

DescriptiveDataStatusText

DescriptiveDataStatusID

 

 

R_76

R_76

Episode

LEpisodeDescriptiveData

EpisodeID

 

 

R_77

R_77

DescriptiveData

LEpisodeDescriptiveData

DescriptiveDataID

 

 

R_78

R_78

Patient

LPatientDescriptiveData

PersonID

 

 

R_79

R_79

DescriptiveData

LPatientDescriptiveData

DescriptiveDataID

 

 

R_80

R_80

Event

LEventDescriptiveData

EventID

 

 

R_81

R_81

DescriptiveData

LEventDescriptiveData

DescriptiveDataID

 

 

R_93

R_93

DescriptiveDataType

LDescriptiveDataTypeOrgUnit

DescriptiveDataTypeID

 

 

R_95

R_95

DescriptiveDataStatus

DescriptiveData

DescriptiveDataStatusID

 

 

R_96

R_96

DescriptiveDataResultType

DescriptiveDataType

DescriptiveDataResultTypeID

 

 

R_97

R_97

DescriptiveDataResultType

DescriptiveDataResultTypeText

DescriptiveDataResultTypeID

 

 

R_182

R_182

UserDefinition

LDescriptivePhraseUser

PersonID

 

 

R_183

R_183

DescriptivePhrase

LDescriptivePhraseUser

DescriptivePhraseID

 

 

R_236

R_236

SysFct

DescriptiveDataType

SysFctID

 

 

R_462

R_462

DescriptiveDataType

DescriptiveDataTypeText

DescriptiveDataTypeID

 

 

R_463

R_463

DescriptiveDataType

DescriptiveData

DescriptiveDataTypeID

 

 

R_464

R_464

Person

DescriptiveData

PersonID

 

 

R_465

R_465

Event

DescriptiveData

EventID

 

 

R_470

R_470

ChangeType

ChangeTypeText

ChangeTypeID

 

 

R_490

R_490

DescriptiveDataType

DescriptiveDataTemplate

DescriptiveDataTypeID

 

 

R_590

R_590

Episode

Event

EpisodeID

 

 

R_611

R_611

Service

PerfService

ServID

 

 

R_632

R_632

DescriptivePhrase

LPhraseDescriptiveDataType

 

 

 

R_636

R_636

DescriptiveDataType

LPhraseDescriptiveDataType

 

 

 

R_660

R_660

Event

PerfService

EventID

 

 

R_825

R_825

DescriptiveDataTypeType

DescriptiveDataType

DescriptiveDataTypeTypeID

 

 

R_826

R_826

DescriptiveDataTypeType

DescriptiveDataTypeTypeText

DescriptiveDataTypeTypeID

 

 

R_828

R_828

SysFileType

DescriptiveData

SysFileTypeID

 

 

R_829

R_829

SysFileType

DescriptiveData

Sys_SysFileTypeID

 

 

R_832

R_832

DescriptiveDataStatus

LDescriptiveDataStatusType

DescriptiveDataStatusID

 

 

R_833

R_833

DescriptiveDataType

LDescriptiveDataStatusType

DescriptiveDataTypeID

 

 

R_841

R_841

DescriptiveDataImport

DescriptiveDataType

DescriptiveDataImportID

 

 

R_843

R_843

DescriptiveDataImport

DescriptiveDataImportText

DescriptiveDataImportID

 

 

R_857

R_857

SysFct

DescriptiveDataTemplate

SysFctID

 

 

R_871

R_871

SysFct

Service

SysFctID

 

 

R_1454

R_1454

DescriptivePhraseType

DescriptivePhraseTypeText

DescriptivePhraseTypeID

 

 

R_1455

R_1455

DescriptivePhraseType

DescriptivePhrase

DescriptivePhraseTypeID

 

 

R_1457

R_1457

Service

LServiceDescriptivePhrase

ServID

 

 

R_1458

R_1458

DescriptivePhrase

LServiceDescriptivePhrase

DescriptivePhraseID

 

 

R_1475

R_1475

SysFct

LSysFctPerfService

SysFctID

 

 

R_1476

R_1476

PerfService

LSysFctPerfService

PerfServiceID

 

 

R_1477

R_1477

Episode

LSysFctPerfService

EpisodeID

 

 

R_1478

R_1478

Event

LSysFctPerfService

EventID

 

 

R_1903

R_1903

DisclosePersonType

DisclosePersonTypeText

DisclosePersonTypeID

 

 

R_1904

R_1904

PerfService

ResultsHandOut

PerfServiceID

 

 

R_1906

R_1906

DisclosePersonType

ResultsHandOut

DisclosePersonTypeID

 

 

R_1907

R_1907

Person

ResultsHandOut

PersonID

 

 

R_1908

R_1908

Kinship

ResultsHandOut

KinshipID

 

 

R_2040

R_2040

Event

DocumentHandsOut

EventID

 

 

R_2042

R_2042

Kinship

DocumentHandsOut

KinshipID

 

 


2